<?php

class Application_Model_DbTable_Role extends Zend_Db_Table_Abstract
{

    protected $_name = 'role';
    public function getRoleName($id){

      $db=$this->getAdapter();
      $stmt = $db-> query("SELECT name FROM role where role_id='$id'");
      $row = $stmt->fetchAll();

      $stmt->closeCursor();
      return $row[0]['name'];

    }
}

